package com.jy.rhin.infra.cda.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.jy.rhin.infra.cda.ertong.LiangSuiRTJKTJVO;
import com.jy.rhin.infra.cda.ertong.SanSuiRTJKTJVO;
import com.jy.rhin.infra.cda.ertong.YISUIETJKTJVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
@DS("health")
public interface ErTongJKTJMapper extends BaseMapper<Object> {

    @Select("select a.*,b.ZHENGJIANHM from   FY_YISUIETJKJC a left join fy_ertongbjk b on a.ERTONGWYBS = b.ERTONGWYBS  ${ew.customSqlSegment}")
    YISUIETJKTJVO getYiSuiET(@Param(Constants.WRAPPER) QueryWrapper<YISUIETJKTJVO> queryWrapper);

    @Select(" select a.*,b.ZHENGJIANHM from   FY_LIANGSUIETJKJC a left join fy_ertongbjk b on a.ERTONGWYBS = b.ERTONGWYBS ${ew.customSqlSegment}")
    LiangSuiRTJKTJVO getLiangSuiET(@Param(Constants.WRAPPER) QueryWrapper<LiangSuiRTJKTJVO> queryWrapper);

    @Select("select a.*,b.ZHENGJIANHM from   FY_SANSUIETJKJC a left join fy_ertongbjk b on a.ERTONGWYBS = b.ERTONGWYBS ${ew.customSqlSegment}")
    SanSuiRTJKTJVO getSanSuiET(@Param(Constants.WRAPPER) QueryWrapper<SanSuiRTJKTJVO> queryWrapper);
}
